To generate a correct cover sheet per transmittal, the engine performs the following main tasks:

• Retrieve the associated cover sheet template file for the current distribution order/transmittal
• Populate the data into the assigned cover sheet(s)
• Save each cover sheet with to its assigned transmittal

{<start_with_object>|<select_data_field>|<condition>}

The engine generates the eQL statements by parsing the input data in the designated template file. It extracts what is between the curly braces and build the queries. In general, if the data field can be retrieved by the current object id, distribution order id or transmittal id, then the data can be on the sheet. The information between the curly braces noted above are:

• start_with_object – It must be one of the following objects: DistributionOrder, Transmittal, TransmittalItem, and TransmittalItemFile.
• select_data_field – The general rule is the engine will support the information that is retrievable from a report in AssetWise Director using eQL syntax. Multiple fields can be in one Excel cell. It will support relationship, scope, and attribute data if a user can make a report on the same data. Furthermore, it can be a computed field for example, a person’s name could be in an English format: <Surname>,<FirstName>.
• condition – The condition in the WHERE clause applied to the data field.

Transmittal|IssuedTo.Surname+', '+IssuedTo.FirstName|Id=500

By using eQL functionality and syntax, we can get all data of the Distribution Order, Transmittal, Distributed documents and Files.